Check whether a value is null or within a range

Use the IS NULL or IS NOT NULL function to check whether a value is null. Use the BETWEEN function to check whether a value is within a range. The results are displayed in a table.

|
SELECT
  http_method IS NULL as "Check whether a value is null",
  http_method IS NOT NULL as "Check whether a value is null (method 2)",
  delta_data_size BETWEEN 2000
  AND 5000 as "Check whether a value is between 2000 and 5000"